package com.his.dao.jpa;

import java.math.BigDecimal;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

import com.his.pojos.jpa.HisTakeinstrument;

public interface MxjTakeInstrumentDAO extends CrudRepository<HisTakeinstrument, Long> {

	@Query("select max(qcNo) from HisTakeinstrument")
	public String findQCMaxid();

	@Query("select qcNo from HisTakeinstrument where qcNo=:qcNo")
	public String inspectQCId(@Param("qcNo")long qcNo);
	
	@Query("select ssNo from HisTakeinstrument where ssNo=:ssNo")
	public String inspectssNo(@Param("ssNo")BigDecimal ssNo);
	
	@Query("select qcNo from HisTakeinstrument where ssNo=:ssNo")
	public BigDecimal findqcNoByssNo(@Param("ssNo")BigDecimal ssNo);
}
